SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_GetLectureTopic]

	(
	@param_date NVARCHAR(120)

	)

AS
	/* SET NOCOUNT ON */
	SELECT JOL_Lecture_No,JOL_Lecture_Title FROM dbo.JOL_Lecture,dbo.JOL_ApplyField WHERE JOL_Lecture_Purpose=JOL_Field_No AND 
	JOL_Field_ApplyTime<=dateadd(dd,1,CONVERT(SMALLDATETIME,@param_date,120)) AND
	JOL_ApplyField_EndTime >= CONVERT(SMALLDATETIME,@param_date,120) AND
	JOL_Lecture_VerifyStatus='已审核'
	RETURN


GO
